/*
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 *
 * Copyright 2010 huliqing, huliqing.cn@gmail.com
 *
 * This file is part of QFaces.
 * QFaces is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * QFaces is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with QFaces.  If not, see <http://www.gnu.org/licenses/>.
 *
 * 这个文件是QFaces的一部分。
 * 您可以单独使用或分发这个文件，但请不要移除这个头部声明信息.
 * QFaces是一个自由软件，您可以自由分发、修改其中的源代码或者重新发布它，
 * 新的任何修改后的重新发布版必须同样在遵守LGPL3或更后续的版本协议下发布.
 * 关于LGPL协议的细则请参考COPYING、COPYING.LESSER文件，
 * 您可以在QFaces的相关目录中获得LGPL协议的副本，
 * 如果没有找到，请连接到 http://www.gnu.org/licenses/ 查看并获取副本。
 *
 * - Author: Huliqing
 * - Contact: huliqing.cn@gmail.com
 * - License: GNU Lesser General Public License (LGPL)
 * - Blog and source code availability: http://www.huliqing.name/
 */

package name.huliqing.qfaces.test.dao;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.EntityTransaction;
import javax.persistence.Query;
import name.huliqing.qfaces.model.PageModel;
import name.huliqing.qfaces.model.PageParam;
import name.huliqing.qfaces.test.BaseDao;
import name.huliqing.qfaces.test.entity.Person;

public class PersonDao extends BaseDao<Person, Long> {

    private static PersonDao ins;

    private PersonDao() {
        super(Person.class);
    }

    public synchronized static PersonDao getInstance() {
        if (ins == null) {
            ins = new PersonDao();
        }
        return ins;
    }

    public Boolean addPersons(List<Person> persons) {
        for (Person p : persons) {
            EntityManager em = this.getEM();
            EntityTransaction tx = em.getTransaction();
            try {
                tx.begin();
                em.persist(p);
                tx.commit();
            } finally {
                if (tx.isActive()) {
                    tx.rollback();
                }
                em.close();
            }
        }
        return true;
    }

    public PageModel<Person> findAll(PageParam pp) {
        String hql_total = "select count(obj) from " + this.t.getName() + " obj";
        String hql_data = "select obj from " + this.t.getName() + " obj";
        EntityManager em = this.getEM();
        Query q1 = em.createQuery(hql_total);
        Query q2 = createQuery(hql_data, pp, em);
        Integer total = (Integer) q1.getSingleResult();
        List<Person> data = q2.getResultList();
        PageModel<Person> pm = new PageModel<Person>();
        pm.setPageData(data);
        pm.setTotal(total);
        return pm;
    }
}
